--SET ANSI_WARNINGS OFF 

/*
SELECT     *
FROM         tbl_ResourceSQL
WHERE     (ParamName = 'Param_1002')

SELECT 	id_Resource, 
	id_Globalization, 
	ParamName, 
	ParamStringValue, 
	ParamObjectValue, 
	ParamType
FROM    tbl_ResourceSQL
*/

DELETE tbl_ResourceSQL

declare @i as int
set @i = 0
while (select @i) < 10001
begin
	INSERT INTO tbl_ResourceSQL (id_Globalization, ParamName, ParamStringValue, ParamObjectValue, ParamType)
	SELECT 	
		'it-it' as id_Globalization, 
		'Param_' + convert(varchar(50),@i) as ParamName, 
		'Val_Param_' + convert(varchar(50),@i) + '_ITA' as ParamStringValue, 
		NULL as ParamObjectValue, 
		'TEST_1' as ParamType
	set @i = @i +1
end



set @i = 0
while (select @i) < 10001
begin
	INSERT INTO tbl_ResourceSQL (id_Globalization, ParamName, ParamStringValue, ParamObjectValue, ParamType)
	SELECT 	
		'en-us' as id_Globalization, 
		'Param_' + convert(varchar(50),@i) as ParamName, 
		'Val_Param_' + convert(varchar(50),@i) + '_ENG' as ParamStringValue, 
		NULL as ParamObjectValue, 
		'TEST_1' as ParamType
	set @i = @i +1
end

